Query
I am using RANDBETWEEN function in Excel to generate random dates and amounts. When I import the excel data in Tally, there is difference between the Excel values and the Tally entries / values. Why does this happen and how to resolve it ?
Answer
The RANDBETWEEN calculates a new value each time the worksheet is calculated. To stop random numbers from being updated, copy the cells that contain RANDBETWEEN to the clipboard, then use "Paste Special > Values" to convert to text. This way the values are not regenerated every time when you import data into Tally.