ExcelBanter - What is the meaning of the plus sign in "=+A1"?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What is the meaning of the plus sign in "=+A1"? (https://www.excelbanter.com/excel-worksheet-functions/154622-re-what-meaning-plus-sign-%3D-a1.html)

Elkar

What is the meaning of the plus sign in "=+A1"?

It has no meaning. It is just a leftover from old Lotus spreadsheets. They
used to have to start formulas with a + sign. Excel allows users to still do
this, but it has absolutely no effect on the formula.

HTH,
Elkar

"qinyg" wrote:

Please advise.

All times are GMT +1. The time now is 03:06 AM.