ExcelBanter - What is the 'Apostrophe' before Excel cell data for?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - What is the 'Apostrophe' before Excel cell data for? (https://www.excelbanter.com/excel-discussion-misc-queries/89676-what-apostrophe-before-excel-cell-data.html)

RabC

What is the 'Apostrophe' before Excel cell data for?

--
RB Campbell

RaymundCG

What is the 'Apostrophe' before Excel cell data for?

Hi!

If apostrophe is placed before a numerical entry, it is converted to text
entry. :)

--
Thanks and kind regards

"RabC" wrote:

--
RB Campbell

All times are GMT +1. The time now is 11:21 PM.