Jun 08 2022 02:33 AM
Hi,
I have an issue in a dataset where the values format in the cell is different from the value in the formula bar. Please see below:
This is inconsistently present as an issue throughout the dataset. Is there any way I can get the formula bar to recognise the value in the cell (D2) as a decimal?
Best,
Alfie
Jun 08 2022 03:04 AM
@Alfieb1996 Looks like a custom format in D2 and perhaps others, but not all.
If you want to have a decimal number (3 decimals I suppose) you need to enter it with the decimal point or us the Advanced setting under Editing options to "Automatically insert a decimal point, 3 places".
Jun 08 2022 04:11 AM
Jun 08 2022 04:26 AM - edited Jun 08 2022 04:27 AM
Assume this is text. On a quick note, you could use the cell with the number divided by 1000 if the numbers are four digits and there is a period after the first number. Example: =A1/1000
or as Mr. Riny_van_Eekelen already mentioned,
Cell Format Custom
Enter: 0"."000
Jun 08 2022 04:31 AM
Jun 08 2022 04:49 AM
SolutionJun 08 2022 04:49 AM
Solution