I am working with a data set that contents a huge number of cells with
decimal figures starting with "." but as I need to export them to access I
need to replace them to figures starting with "0."
How can I do it?

Hi,

It sounds like the data is either formatted that way (rather unusual) or it
is text data.

So just to clarify, since you didn't show a single example, you see things
like .1234
and you want 0.1234?

Select a cell with one of the problems and observe the formula bar - is the
entry on the formula bar different? In other words does the Formula Bar show
0.1234 while the cell displays .1234?

If so this can be cleared up by changing the format of all the cells.
Select the entire spreadsheet or the portion with this problem and choose
Format, Cells, Number tab, and pick General.

If the entries on the formula bar match the entries in the spreadsheet, both
..1234, then the problem probably is that the cells are formatted as text for
one reason or another.
1. Press Shift+F11.
2. With a single empty cell selected on the new sheet choose Copy
3. Switch back the the sheet with the problem and highlight the problem cells
4. Choose Edit, Paste Special, Add.

See if the entries have converted to numbers with the leading zeros showing.

--
Thanks,
Shane Devenshire


"Julio" wrote:

I am working with a data set that contents a huge number of cells with
decimal figures starting with "." but as I need to export them to access I
need to replace them to figures starting with "0."
How can I do it?

Thank you, my case was the second one. My data was for some reason in text
format and following your recomendation I could transform it back to the
format I needed.
Thank you again!

Julio

"ShaneDevenshire" wrote:

Hi,

It sounds like the data is either formatted that way (rather unusual) or it
is text data.

So just to clarify, since you didn't show a single example, you see things
like .1234
and you want 0.1234?

Select a cell with one of the problems and observe the formula bar - is the
entry on the formula bar different? In other words does the Formula Bar show
0.1234 while the cell displays .1234?

If so this can be cleared up by changing the format of all the cells.
Select the entire spreadsheet or the portion with this problem and choose
Format, Cells, Number tab, and pick General.

If the entries on the formula bar match the entries in the spreadsheet, both
.1234, then the problem probably is that the cells are formatted as text for
one reason or another.
1. Press Shift+F11.
2. With a single empty cell selected on the new sheet choose Copy
3. Switch back the the sheet with the problem and highlight the problem cells
4. Choose Edit, Paste Special, Add.

See if the entries have converted to numbers with the leading zeros showing.

--
Thanks,
Shane Devenshire


"Julio" wrote:

I am working with a data set that contents a huge number of cells with
decimal figures starting with "." but as I need to export them to access I
need to replace them to figures starting with "0."
How can I do it?